Create Dictionary Tables in ODS Database and Populate the Dictionary Tables 12

Download the SQL File attached to the 

Run Script that is attached to create your Dictionary tables in the ODS Database. Once ran, the tables will be made up of these columns.




After creating the Dictionary tables in ODS Database, use SSIS to populate the Dictionary tables, create "LoadDictionaryTables" Package





DFT- DictionaryIncident



Derived Column "IncidentCategory"
IncidentType == "HIT SHOOTING INCIDENT" ? 1 : IncidentType == "NON-HIT SHOOTING INCIDENT" ? 0 : 


DFT- DictionaryLocation


DFT- DictionaryDistrict



DFT- DictionaryRace



DFT- DictionaryHandlingUnit



DFT- DictionaryWeapon



DFT- ShootingIncident



Execute the package to populate the Dictionary tables with the data



The Dictionary tables are populated with Data



Lookup Transformation